SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO



CREATE PROCEDURE [dbo].[usp_StatisticsRecruitmentSearch]
    (
      @param_JOL_Statistics_StartTime VARCHAR(20),
      @param_JOL_Statistics_EndTime VARCHAR(20)
    )
AS
	SET @param_JOL_Statistics_StartTime = @param_JOL_Statistics_StartTime + '-01'
	SET @param_JOL_Statistics_EndTime = @param_JOL_Statistics_EndTime + '-01'
    SELECT 
		Statistics_ID AS JOL_Statistics_ID,
		DATENAME(YEAR,Statistics_Date) + '年' + DATENAME(MONTH,Statistics_Date) + '月' AS JOL_Statistics_Date,
		Statistics_OnCampus + Statistics_OnNet + Statistics_TheOthers AS JOL_Statistics_MonthCount,
		Statistics_OnCampus AS JOL_Statistics_OnCampus,
		Statistics_OnCampusUnit AS JOL_Statistics_OnCampusUnit,
		Statistics_OnCampusBooth AS JOL_Statistics_OnCampusBooth,
		Statistics_OnCampusRecruitmentNUM AS JOL_Statistics_OnCampusRecruitmentNUM,
		Statistics_OnNet AS JOL_Statistics_OnNet,
		Statistics_OnNetUnit AS JOL_Statistics_OnNetUnit,
		Statistics_OnNetBooth AS JOL_Statistics_OnNetBooth,
		Statistics_OnNetRecruitmentNUM AS JOL_Statistics_OnNetRecruitmentNUM,
		Statistics_OnNetEmployNUM AS JOL_Statistics_OnNetEmployNUM,
		Statistics_TheOthers AS JOL_Statistics_TheOthers
    FROM  dbo.JOL_Statistics_Recruitment
    WHERE @param_JOL_Statistics_StartTime <= Statistics_Date AND Statistics_Date <= @param_JOL_Statistics_EndTime
    ORDER BY Statistics_Date
	RETURN



GO
